home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / prpend.sql < prev    next >
Text File  |  2000-05-12  |  2KB  |  35 lines
  1. /* RCSVER $Id: prpend.sql,v 1.2 1999-12-02 16:58:34-06 randy CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        prpend    
  6. * Date:        08/18/1999
  7. * memo:        Randy Wood
  8. * Description:    Create the prpend table.  This table contains
  9. *        unclosed probed data counts.     
  10. * Changes:
  11. ************************************************************************* */
  12. CREATE TABLE prpend
  13. (
  14.     prpend_indx        NUMBER(38),    /* index for this probe */
  15.     farebox_glid        NUMBER(38),    /* farebox number */
  16.     cashbox_glid        NUMBER(38),    /* cashbox number */
  17.     cb_sernum        VARCHAR2(20),    /* cashbox ID */
  18.     cbinsert_seq        NUMBER(38),    /* number from cbinsert table */
  19.     cbremov_seq         NUMBER(38),    /* number from cbremov table */
  20.     cbinsert_date        DATE,        /* date of cashbox insert */
  21.     cbremov_date        DATE,        /* date of cashbox removal */
  22.     last_curstate        NUMBER(38),    /* last curstate prior to removal */
  23.     revenue_service_seq    NUMBER(38),    /* revenue sequence number from curstate */
  24.     bill_totals        NUMBER(36,2),    /* total of bills in cashbox */
  25.     coin_totals        NUMBER(36,2),    /* totals of coins in cashbox */
  26.     tot_amount        NUMBER(36,2),    /* amount in cashbox */
  27.     subbatch_seq        NUMBER(38),    /* matched count */
  28.     conversion_num        NUMBER(38),    /* probe convert number */
  29.     pull_intent        NUMBER(38),    /* intent to pull (1/0) */
  30.     probe_date        DATE,
  31.     curacc_totals        NUMBER(36,2),
  32.     revenue_service_time    DATE,        /* Cashbox insert time */
  33.     CONSTRAINT pk_prpend PRIMARY KEY (prpend_indx)
  34. );
  35.